package com.example.fitnessservice.module.dao.courseMapper;

import com.example.fitnessservice.module.pojo.CourseDetails;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author:XuRui
 * @Date:2022/11/24 10:09
 */
@Mapper
public interface CoachCourseMapper {
    @Select("select * from course_details cd,coach_course cc where cd.id=cc.cuid and cc.cid=#{cid}")
    public List<CourseDetails> findByCid(Integer cid);

    @Select("select * from course_details where id=#{cid}")
    public CourseDetails findTimeByCid(Integer cid);

    @Select("select * from course_details where id=#{cid}")
    public CourseDetails findCourseByCid(Integer cid);
}
